package jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class Demo10 {
    public static void main(String[] args) {
        try ( Connection connection = DBUtil.getConnection();){
         String sql="UPDATE user  " +
                 "SET password=?,nickname=?,age=? " +
                 "WHERE id=?";
         PreparedStatement ps=connection.prepareStatement(sql);
        ps.setString(1,"888888");
        ps.setString(2,"老三");
        ps.setInt(3,19);
        ps.setInt(4,8);
        int num=ps.executeUpdate();
        System.out.println(num>0?"修改成功":"修改失败");
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}
